Exploratory Analysis and Dashboards


Milestone 3: Exploratory Analysis and Dashboard Submission

Once we have the data pre-processed, we are ready to roll up our sleeves and begin exploring the data in earnest. In this milestone you will use the skills that you have learned in the specialization to perform exploratory analysis of your data. You will identify key metrics in the data and create KPIs to track those metrics. We will use those KPIs to create dashboards that allow for comparative views and “brushing and linking” of the data. This will allow us to begin to think about the proper context of developing an explanatory analysis that will form the basis for the remaining milestones.

Remember that at this point, your design decisions should be made to facilitate exploration of the data, so be sure your KPIs and worksheets demonstrate the visual and cognitive design principles learned in throughout the Specialization. In particular, and make use of advanced features like hierarchies, actions, filters and parameters.

You will submit a URL to your worksheets or dashboard on Tableau Public containing your KPIs (key metrics) for this project. Your worksheets or dashboard must make use of at least one design principle and at least one KPI principle taught in this course. You will also submit a written narrative answering specific questions.

Import Libraries

Data Visualization

Groupby Function

Univariate Data Exploration

Time-Series Analysis

Correlation

Answer These Questions

Why are these KPIs key to answering your business question or achieving your project goals? What specific insight did these KPIs or worksheets provide you?

These KPIs gave insights how these will affect workers productivity in terms of days, teams, incentives etc.

How does your dashboard or worksheet(s) exemplify use of at least one pre-attentive attribute?

The usage of colors to make distinctions or highlight important areas.

How does your dashboard or worksheet(s) exemplify use of at least one of the following KPI principles?

The graphs able to highlight main points in this dashboard

Do these worksheets meet the needs of your intended audience as-is? How might they need to be changed before ultimately being presented?

Yes, I made them as easy to understand as possible.

Python code done by Dennis Lam